{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import re\n",
    "\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "def read_items_from_file(file):\n",
    "    with open(file, 'r') as f:\n",
    "        return [list(map(int, re.findall('-?\\d+', line))) for line in f.readlines() if not line.startswith('#')]\n",
    "\n",
    "def gen_df(items_list, columns=None, index=None, sort_values=None, ascending=None):\n",
    "    df = pd.DataFrame(items_list, columns=columns)\n",
    "    if index:\n",
    "        df = df.set_index(index, inplace=False)\n",
    "    if sort_values:\n",
    "        df = df.sort_values(sort_values, ascending=ascending)\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "cars_list = read_items_from_file('car.txt')\n",
    "roads_list = read_items_from_file('road.txt')\n",
    "crosses_list = read_items_from_file('cross.txt')\n",
    "preset_list = read_items_from_file('presetAnswer.txt')\n",
    "preset_list = [[item[0], item[1], item[2:]] for item in preset_list]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "cars_df = gen_df(cars_list, columns=['id', 'from_id', 'to_id', 'speed', 'plan_time', 'priority', 'preset'], index=['id'], sort_values=['priority', 'id'], ascending=[False, True])\n",
    "roads_df = gen_df(roads_list, columns=['id', 'length', 'speed', 'lanes', 'from_id', 'to_id', 'is_duplex'], index=['id'], sort_values=['to_id', 'id'])\n",
    "crosses_df = gen_df(crosses_list, columns=['id', 'road_1', 'road_2', 'road_3', 'road_4'], index=['id'], sort_values=['id'])\n",
    "preset_df = gen_df(preset_list, columns=['id', 'real_time', 'preset_path'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>road_1</th>\n",
       "      <th>road_2</th>\n",
       "      <th>road_3</th>\n",
       "      <th>road_4</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1989</th>\n",
       "      <td>1989</td>\n",
       "      <td>-1</td>\n",
       "      <td>5526</td>\n",
       "      <td>5244</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1984</th>\n",
       "      <td>1984</td>\n",
       "      <td>-1</td>\n",
       "      <td>5470</td>\n",
       "      <td>6947</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1982</th>\n",
       "      <td>1982</td>\n",
       "      <td>5339</td>\n",
       "      <td>6807</td>\n",
       "      <td>5673</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981</th>\n",
       "      <td>1981</td>\n",
       "      <td>5345</td>\n",
       "      <td>6566</td>\n",
       "      <td>6502</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1968</th>\n",
       "      <td>1968</td>\n",
       "      <td>-1</td>\n",
       "      <td>6449</td>\n",
       "      <td>5206</td>\n",
       "      <td>5906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1957</th>\n",
       "      <td>1957</td>\n",
       "      <td>5829</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>5933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1953</th>\n",
       "      <td>1953</td>\n",
       "      <td>-1</td>\n",
       "      <td>6841</td>\n",
       "      <td>6540</td>\n",
       "      <td>6502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1933</th>\n",
       "      <td>1933</td>\n",
       "      <td>6124</td>\n",
       "      <td>6036</td>\n",
       "      <td>6065</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1927</th>\n",
       "      <td>1927</td>\n",
       "      <td>6119</td>\n",
       "      <td>5470</td>\n",
       "      <td>-1</td>\n",
       "      <td>6939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1901</th>\n",
       "      <td>1901</td>\n",
       "      <td>5675</td>\n",
       "      <td>5691</td>\n",
       "      <td>5857</td>\n",
       "      <td>6375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1897</th>\n",
       "      <td>1897</td>\n",
       "      <td>5957</td>\n",
       "      <td>6346</td>\n",
       "      <td>5519</td>\n",
       "      <td>5791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852</th>\n",
       "      <td>1852</td>\n",
       "      <td>5204</td>\n",
       "      <td>6689</td>\n",
       "      <td>-1</td>\n",
       "      <td>5707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1827</th>\n",
       "      <td>1827</td>\n",
       "      <td>6623</td>\n",
       "      <td>5612</td>\n",
       "      <td>-1</td>\n",
       "      <td>6235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824</th>\n",
       "      <td>1824</td>\n",
       "      <td>6179</td>\n",
       "      <td>-1</td>\n",
       "      <td>5739</td>\n",
       "      <td>6575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1803</th>\n",
       "      <td>1803</td>\n",
       "      <td>5847</td>\n",
       "      <td>-1</td>\n",
       "      <td>5477</td>\n",
       "      <td>5469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1795</th>\n",
       "      <td>1795</td>\n",
       "      <td>6329</td>\n",
       "      <td>6288</td>\n",
       "      <td>5181</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1779</th>\n",
       "      <td>1779</td>\n",
       "      <td>6369</td>\n",
       "      <td>5090</td>\n",
       "      <td>6970</td>\n",
       "      <td>5114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1770</th>\n",
       "      <td>1770</td>\n",
       "      <td>5244</td>\n",
       "      <td>6054</td>\n",
       "      <td>6096</td>\n",
       "      <td>5270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1764</th>\n",
       "      <td>1764</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>5689</td>\n",
       "      <td>6097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1758</th>\n",
       "      <td>1758</td>\n",
       "      <td>6387</td>\n",
       "      <td>6375</td>\n",
       "      <td>5709</td>\n",
       "      <td>5108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1748</th>\n",
       "      <td>1748</td>\n",
       "      <td>-1</td>\n",
       "      <td>6065</td>\n",
       "      <td>5247</td>\n",
       "      <td>5456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1709</th>\n",
       "      <td>1709</td>\n",
       "      <td>5378</td>\n",
       "      <td>5774</td>\n",
       "      <td>6073</td>\n",
       "      <td>5885</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1692</th>\n",
       "      <td>1692</td>\n",
       "      <td>5129</td>\n",
       "      <td>6508</td>\n",
       "      <td>5921</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1689</th>\n",
       "      <td>1689</td>\n",
       "      <td>6575</td>\n",
       "      <td>6629</td>\n",
       "      <td>5108</td>\n",
       "      <td>5408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1686</th>\n",
       "      <td>1686</td>\n",
       "      <td>-1</td>\n",
       "      <td>5574</td>\n",
       "      <td>6328</td>\n",
       "      <td>6200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1677</th>\n",
       "      <td>1677</td>\n",
       "      <td>5408</td>\n",
       "      <td>6262</td>\n",
       "      <td>-1</td>\n",
       "      <td>5892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1653</th>\n",
       "      <td>1653</td>\n",
       "      <td>-1</td>\n",
       "      <td>6650</td>\n",
       "      <td>6039</td>\n",
       "      <td>5746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1610</th>\n",
       "      <td>1610</td>\n",
       "      <td>6612</td>\n",
       "      <td>6225</td>\n",
       "      <td>-1</td>\n",
       "      <td>5489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1599</th>\n",
       "      <td>1599</td>\n",
       "      <td>6012</td>\n",
       "      <td>-1</td>\n",
       "      <td>6450</td>\n",
       "      <td>6755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1540</th>\n",
       "      <td>1540</td>\n",
       "      <td>6530</td>\n",
       "      <td>6258</td>\n",
       "      <td>6810</td>\n",
       "      <td>5675</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342</th>\n",
       "      <td>342</td>\n",
       "      <td>5857</td>\n",
       "      <td>5846</td>\n",
       "      <td>-1</td>\n",
       "      <td>6706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>303</th>\n",
       "      <td>303</td>\n",
       "      <td>5742</td>\n",
       "      <td>6284</td>\n",
       "      <td>6329</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>277</td>\n",
       "      <td>-1</td>\n",
       "      <td>6478</td>\n",
       "      <td>6073</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>268</td>\n",
       "      <td>6796</td>\n",
       "      <td>-1</td>\n",
       "      <td>6444</td>\n",
       "      <td>6361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264</th>\n",
       "      <td>264</td>\n",
       "      <td>5984</td>\n",
       "      <td>6369</td>\n",
       "      <td>6234</td>\n",
       "      <td>5882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>238</td>\n",
       "      <td>6096</td>\n",
       "      <td>6742</td>\n",
       "      <td>5680</td>\n",
       "      <td>6325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>224</td>\n",
       "      <td>6365</td>\n",
       "      <td>-1</td>\n",
       "      <td>5713</td>\n",
       "      <td>6433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>223</td>\n",
       "      <td>5535</td>\n",
       "      <td>5988</td>\n",
       "      <td>6909</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>199</td>\n",
       "      <td>5216</td>\n",
       "      <td>6006</td>\n",
       "      <td>6119</td>\n",
       "      <td>6089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>191</td>\n",
       "      <td>5831</td>\n",
       "      <td>6644</td>\n",
       "      <td>5475</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>179</td>\n",
       "      <td>6549</td>\n",
       "      <td>6225</td>\n",
       "      <td>6047</td>\n",
       "      <td>5196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>176</td>\n",
       "      <td>6510</td>\n",
       "      <td>-1</td>\n",
       "      <td>6721</td>\n",
       "      <td>5514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>174</td>\n",
       "      <td>5505</td>\n",
       "      <td>5255</td>\n",
       "      <td>6081</td>\n",
       "      <td>6970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>173</td>\n",
       "      <td>5795</td>\n",
       "      <td>5043</td>\n",
       "      <td>-1</td>\n",
       "      <td>5089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>171</td>\n",
       "      <td>5911</td>\n",
       "      <td>5207</td>\n",
       "      <td>5326</td>\n",
       "      <td>5289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>156</td>\n",
       "      <td>-1</td>\n",
       "      <td>6947</td>\n",
       "      <td>6006</td>\n",
       "      <td>5477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>141</td>\n",
       "      <td>5130</td>\n",
       "      <td>5269</td>\n",
       "      <td>6188</td>\n",
       "      <td>6236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>130</td>\n",
       "      <td>5610</td>\n",
       "      <td>5469</td>\n",
       "      <td>5216</td>\n",
       "      <td>6653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>120</td>\n",
       "      <td>5207</td>\n",
       "      <td>5206</td>\n",
       "      <td>5519</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>115</td>\n",
       "      <td>5481</td>\n",
       "      <td>-1</td>\n",
       "      <td>6629</td>\n",
       "      <td>6608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>111</td>\n",
       "      <td>6068</td>\n",
       "      <td>6549</td>\n",
       "      <td>6687</td>\n",
       "      <td>6484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>107</td>\n",
       "      <td>6939</td>\n",
       "      <td>-1</td>\n",
       "      <td>6716</td>\n",
       "      <td>5464</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>105</td>\n",
       "      <td>6794</td>\n",
       "      <td>5683</td>\n",
       "      <td>5130</td>\n",
       "      <td>6864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>104</td>\n",
       "      <td>5933</td>\n",
       "      <td>6539</td>\n",
       "      <td>5127</td>\n",
       "      <td>5436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>99</td>\n",
       "      <td>5885</td>\n",
       "      <td>5453</td>\n",
       "      <td>-1</td>\n",
       "      <td>5608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>58</td>\n",
       "      <td>5906</td>\n",
       "      <td>5911</td>\n",
       "      <td>6552</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>48</td>\n",
       "      <td>6036</td>\n",
       "      <td>6158</td>\n",
       "      <td>5731</td>\n",
       "      <td>5278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>5266</td>\n",
       "      <td>-1</td>\n",
       "      <td>5612</td>\n",
       "      <td>5269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>5301</td>\n",
       "      <td>6540</td>\n",
       "      <td>6627</td>\n",
       "      <td>6653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>6039</td>\n",
       "      <td>6001</td>\n",
       "      <td>-1</td>\n",
       "      <td>5640</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>141 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id  road_1  road_2  road_3  road_4\n",
       "id                                        \n",
       "1989  1989      -1    5526    5244      -1\n",
       "1984  1984      -1    5470    6947      -1\n",
       "1982  1982    5339    6807    5673      -1\n",
       "1981  1981    5345    6566    6502      -1\n",
       "1968  1968      -1    6449    5206    5906\n",
       "1957  1957    5829      -1      -1    5933\n",
       "1953  1953      -1    6841    6540    6502\n",
       "1933  1933    6124    6036    6065      -1\n",
       "1927  1927    6119    5470      -1    6939\n",
       "1901  1901    5675    5691    5857    6375\n",
       "1897  1897    5957    6346    5519    5791\n",
       "1852  1852    5204    6689      -1    5707\n",
       "1827  1827    6623    5612      -1    6235\n",
       "1824  1824    6179      -1    5739    6575\n",
       "1803  1803    5847      -1    5477    5469\n",
       "1795  1795    6329    6288    5181      -1\n",
       "1779  1779    6369    5090    6970    5114\n",
       "1770  1770    5244    6054    6096    5270\n",
       "1764  1764      -1      -1    5689    6097\n",
       "1758  1758    6387    6375    5709    5108\n",
       "1748  1748      -1    6065    5247    5456\n",
       "1709  1709    5378    5774    6073    5885\n",
       "1692  1692    5129    6508    5921      -1\n",
       "1689  1689    6575    6629    5108    5408\n",
       "1686  1686      -1    5574    6328    6200\n",
       "1677  1677    5408    6262      -1    5892\n",
       "1653  1653      -1    6650    6039    5746\n",
       "1610  1610    6612    6225      -1    5489\n",
       "1599  1599    6012      -1    6450    6755\n",
       "1540  1540    6530    6258    6810    5675\n",
       "...    ...     ...     ...     ...     ...\n",
       "342    342    5857    5846      -1    6706\n",
       "303    303    5742    6284    6329      -1\n",
       "277    277      -1    6478    6073      -1\n",
       "268    268    6796      -1    6444    6361\n",
       "264    264    5984    6369    6234    5882\n",
       "238    238    6096    6742    5680    6325\n",
       "224    224    6365      -1    5713    6433\n",
       "223    223    5535    5988    6909      -1\n",
       "199    199    5216    6006    6119    6089\n",
       "191    191    5831    6644    5475      -1\n",
       "179    179    6549    6225    6047    5196\n",
       "176    176    6510      -1    6721    5514\n",
       "174    174    5505    5255    6081    6970\n",
       "173    173    5795    5043      -1    5089\n",
       "171    171    5911    5207    5326    5289\n",
       "156    156      -1    6947    6006    5477\n",
       "141    141    5130    5269    6188    6236\n",
       "130    130    5610    5469    5216    6653\n",
       "120    120    5207    5206    5519      -1\n",
       "115    115    5481      -1    6629    6608\n",
       "111    111    6068    6549    6687    6484\n",
       "107    107    6939      -1    6716    5464\n",
       "105    105    6794    5683    5130    6864\n",
       "104    104    5933    6539    5127    5436\n",
       "99      99    5885    5453      -1    5608\n",
       "58      58    5906    5911    6552      -1\n",
       "48      48    6036    6158    5731    5278\n",
       "27      27    5266      -1    5612    5269\n",
       "22      22    5301    6540    6627    6653\n",
       "6        6    6039    6001      -1    5640\n",
       "\n",
       "[141 rows x 5 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "crosses_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>length</th>\n",
       "      <th>speed</th>\n",
       "      <th>lanes</th>\n",
       "      <th>from_id</th>\n",
       "      <th>to_id</th>\n",
       "      <th>is_duplex</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5640</th>\n",
       "      <td>5640</td>\n",
       "      <td>30</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>1061</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5301</th>\n",
       "      <td>5301</td>\n",
       "      <td>36</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>970</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6653</th>\n",
       "      <td>6653</td>\n",
       "      <td>30</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>130</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5266</th>\n",
       "      <td>5266</td>\n",
       "      <td>24</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>1208</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5269</th>\n",
       "      <td>5269</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>141</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5278</th>\n",
       "      <td>5278</td>\n",
       "      <td>24</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>634</td>\n",
       "      <td>48</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6036</th>\n",
       "      <td>6036</td>\n",
       "      <td>36</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>1933</td>\n",
       "      <td>48</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6552</th>\n",
       "      <td>6552</td>\n",
       "      <td>40</td>\n",
       "      <td>15</td>\n",
       "      <td>4</td>\n",
       "      <td>1020</td>\n",
       "      <td>58</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5453</th>\n",
       "      <td>5453</td>\n",
       "      <td>24</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>1515</td>\n",
       "      <td>99</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5127</th>\n",
       "      <td>5127</td>\n",
       "      <td>40</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>1378</td>\n",
       "      <td>104</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5436</th>\n",
       "      <td>5436</td>\n",
       "      <td>30</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>496</td>\n",
       "      <td>104</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6794</th>\n",
       "      <td>6794</td>\n",
       "      <td>20</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>417</td>\n",
       "      <td>105</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6864</th>\n",
       "      <td>6864</td>\n",
       "      <td>40</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>456</td>\n",
       "      <td>105</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6939</th>\n",
       "      <td>6939</td>\n",
       "      <td>36</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>1927</td>\n",
       "      <td>107</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6068</th>\n",
       "      <td>6068</td>\n",
       "      <td>24</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>1034</td>\n",
       "      <td>111</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6549</th>\n",
       "      <td>6549</td>\n",
       "      <td>30</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>179</td>\n",
       "      <td>111</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5481</th>\n",
       "      <td>5481</td>\n",
       "      <td>36</td>\n",
       "      <td>15</td>\n",
       "      <td>4</td>\n",
       "      <td>1218</td>\n",
       "      <td>115</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6608</th>\n",
       "      <td>6608</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>1239</td>\n",
       "      <td>115</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5206</th>\n",
       "      <td>5206</td>\n",
       "      <td>30</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>1968</td>\n",
       "      <td>120</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5207</th>\n",
       "      <td>5207</td>\n",
       "      <td>30</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>171</td>\n",
       "      <td>120</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5216</th>\n",
       "      <td>5216</td>\n",
       "      <td>36</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>199</td>\n",
       "      <td>130</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5469</th>\n",
       "      <td>5469</td>\n",
       "      <td>20</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>1803</td>\n",
       "      <td>130</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5130</th>\n",
       "      <td>5130</td>\n",
       "      <td>36</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>105</td>\n",
       "      <td>141</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6236</th>\n",
       "      <td>6236</td>\n",
       "      <td>30</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>1243</td>\n",
       "      <td>141</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6947</th>\n",
       "      <td>6947</td>\n",
       "      <td>36</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>1984</td>\n",
       "      <td>156</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5289</th>\n",
       "      <td>5289</td>\n",
       "      <td>20</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>1189</td>\n",
       "      <td>171</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5911</th>\n",
       "      <td>5911</td>\n",
       "      <td>36</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>58</td>\n",
       "      <td>171</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5089</th>\n",
       "      <td>5089</td>\n",
       "      <td>30</td>\n",
       "      <td>15</td>\n",
       "      <td>4</td>\n",
       "      <td>1330</td>\n",
       "      <td>173</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5505</th>\n",
       "      <td>5505</td>\n",
       "      <td>20</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>1207</td>\n",
       "      <td>174</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6970</th>\n",
       "      <td>6970</td>\n",
       "      <td>36</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>1779</td>\n",
       "      <td>174</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5885</th>\n",
       "      <td>5885</td>\n",
       "      <td>24</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>99</td>\n",
       "      <td>1709</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6073</th>\n",
       "      <td>6073</td>\n",
       "      <td>30</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>277</td>\n",
       "      <td>1709</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5456</th>\n",
       "      <td>5456</td>\n",
       "      <td>36</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>460</td>\n",
       "      <td>1748</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5108</th>\n",
       "      <td>5108</td>\n",
       "      <td>40</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>1689</td>\n",
       "      <td>1758</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6387</th>\n",
       "      <td>6387</td>\n",
       "      <td>40</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>635</td>\n",
       "      <td>1758</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6097</th>\n",
       "      <td>6097</td>\n",
       "      <td>30</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>1519</td>\n",
       "      <td>1764</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5244</th>\n",
       "      <td>5244</td>\n",
       "      <td>20</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>1989</td>\n",
       "      <td>1770</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5270</th>\n",
       "      <td>5270</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>719</td>\n",
       "      <td>1770</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5090</th>\n",
       "      <td>5090</td>\n",
       "      <td>36</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>1159</td>\n",
       "      <td>1779</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6369</th>\n",
       "      <td>6369</td>\n",
       "      <td>24</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>264</td>\n",
       "      <td>1779</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5181</th>\n",
       "      <td>5181</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>1271</td>\n",
       "      <td>1795</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6288</th>\n",
       "      <td>6288</td>\n",
       "      <td>20</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>740</td>\n",
       "      <td>1795</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5477</th>\n",
       "      <td>5477</td>\n",
       "      <td>30</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>156</td>\n",
       "      <td>1803</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5739</th>\n",
       "      <td>5739</td>\n",
       "      <td>30</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>1239</td>\n",
       "      <td>1824</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5612</th>\n",
       "      <td>5612</td>\n",
       "      <td>24</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>27</td>\n",
       "      <td>1827</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6623</th>\n",
       "      <td>6623</td>\n",
       "      <td>40</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>1046</td>\n",
       "      <td>1827</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6689</th>\n",
       "      <td>6689</td>\n",
       "      <td>40</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>1471</td>\n",
       "      <td>1852</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5519</th>\n",
       "      <td>5519</td>\n",
       "      <td>36</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>120</td>\n",
       "      <td>1897</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5791</th>\n",
       "      <td>5791</td>\n",
       "      <td>36</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>1519</td>\n",
       "      <td>1897</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5675</th>\n",
       "      <td>5675</td>\n",
       "      <td>40</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>1540</td>\n",
       "      <td>1901</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6375</th>\n",
       "      <td>6375</td>\n",
       "      <td>36</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>1758</td>\n",
       "      <td>1901</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5470</th>\n",
       "      <td>5470</td>\n",
       "      <td>30</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>1984</td>\n",
       "      <td>1927</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6065</th>\n",
       "      <td>6065</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>1748</td>\n",
       "      <td>1933</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6502</th>\n",
       "      <td>6502</td>\n",
       "      <td>20</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>1981</td>\n",
       "      <td>1953</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6540</th>\n",
       "      <td>6540</td>\n",
       "      <td>40</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>1953</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5829</th>\n",
       "      <td>5829</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>932</td>\n",
       "      <td>1957</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5933</th>\n",
       "      <td>5933</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>104</td>\n",
       "      <td>1957</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5906</th>\n",
       "      <td>5906</td>\n",
       "      <td>40</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>58</td>\n",
       "      <td>1968</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5345</th>\n",
       "      <td>5345</td>\n",
       "      <td>20</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>1169</td>\n",
       "      <td>1981</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5339</th>\n",
       "      <td>5339</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>560</td>\n",
       "      <td>1982</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>226 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id  length  speed  lanes  from_id  to_id  is_duplex\n",
       "id                                                         \n",
       "5640  5640      30     15      1     1061      6          1\n",
       "5301  5301      36     12      4      970     22          1\n",
       "6653  6653      30     15      3      130     22          1\n",
       "5266  5266      24     15      1     1208     27          1\n",
       "5269  5269      20     10      2      141     27          1\n",
       "5278  5278      24     12      2      634     48          1\n",
       "6036  6036      36     12      4     1933     48          1\n",
       "6552  6552      40     15      4     1020     58          1\n",
       "5453  5453      24     12      4     1515     99          1\n",
       "5127  5127      40     12      1     1378    104          0\n",
       "5436  5436      30     12      1      496    104          1\n",
       "6794  6794      20     12      1      417    105          1\n",
       "6864  6864      40     12      1      456    105          0\n",
       "6939  6939      36      8      4     1927    107          1\n",
       "6068  6068      24     12      1     1034    111          1\n",
       "6549  6549      30      8      2      179    111          1\n",
       "5481  5481      36     15      4     1218    115          1\n",
       "6608  6608      20     10      1     1239    115          1\n",
       "5206  5206      30     10      2     1968    120          1\n",
       "5207  5207      30     15      1      171    120          1\n",
       "5216  5216      36     10      4      199    130          1\n",
       "5469  5469      20      8      1     1803    130          1\n",
       "5130  5130      36     10      1      105    141          1\n",
       "6236  6236      30      8      3     1243    141          1\n",
       "6947  6947      36      8      2     1984    156          1\n",
       "5289  5289      20     12      1     1189    171          1\n",
       "5911  5911      36      8      1       58    171          1\n",
       "5089  5089      30     15      4     1330    173          1\n",
       "5505  5505      20     15      1     1207    174          1\n",
       "6970  6970      36     15      1     1779    174          1\n",
       "...    ...     ...    ...    ...      ...    ...        ...\n",
       "5885  5885      24      8      3       99   1709          1\n",
       "6073  6073      30     10      3      277   1709          1\n",
       "5456  5456      36     10      1      460   1748          1\n",
       "5108  5108      40     15      3     1689   1758          1\n",
       "6387  6387      40     10      3      635   1758          1\n",
       "6097  6097      30      8      2     1519   1764          1\n",
       "5244  5244      20     12      1     1989   1770          1\n",
       "5270  5270      20     10      1      719   1770          1\n",
       "5090  5090      36     10      4     1159   1779          1\n",
       "6369  6369      24     10      2      264   1779          0\n",
       "5181  5181      20     10      4     1271   1795          1\n",
       "6288  6288      20     12      3      740   1795          1\n",
       "5477  5477      30     10      1      156   1803          1\n",
       "5739  5739      30     12      2     1239   1824          1\n",
       "5612  5612      24      8      4       27   1827          1\n",
       "6623  6623      40      8      2     1046   1827          1\n",
       "6689  6689      40     12      2     1471   1852          1\n",
       "5519  5519      36     12      1      120   1897          1\n",
       "5791  5791      36      8      4     1519   1897          1\n",
       "5675  5675      40      8      4     1540   1901          0\n",
       "6375  6375      36     15      1     1758   1901          1\n",
       "5470  5470      30     10      3     1984   1927          1\n",
       "6065  6065      20     10      4     1748   1933          1\n",
       "6502  6502      20     15      1     1981   1953          1\n",
       "6540  6540      40     10      1       22   1953          1\n",
       "5829  5829      20     10      3      932   1957          1\n",
       "5933  5933      20     10      3      104   1957          1\n",
       "5906  5906      40     12      4       58   1968          1\n",
       "5345  5345      20     15      3     1169   1981          1\n",
       "5339  5339      20     10      1      560   1982          1\n",
       "\n",
       "[226 rows x 7 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "roads_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>from_id</th>\n",
       "      <th>to_id</th>\n",
       "      <th>speed</th>\n",
       "      <th>plan_time</th>\n",
       "      <th>priority</th>\n",
       "      <th>preset</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10010</th>\n",
       "      <td>10010</td>\n",
       "      <td>706</td>\n",
       "      <td>1827</td>\n",
       "      <td>14</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10033</th>\n",
       "      <td>10033</td>\n",
       "      <td>634</td>\n",
       "      <td>176</td>\n",
       "      <td>14</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10039</th>\n",
       "      <td>10039</td>\n",
       "      <td>1901</td>\n",
       "      <td>1519</td>\n",
       "      <td>6</td>\n",
       "      <td>47</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10040</th>\n",
       "      <td>10040</td>\n",
       "      <td>1927</td>\n",
       "      <td>1009</td>\n",
       "      <td>16</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10050</th>\n",
       "      <td>10050</td>\n",
       "      <td>1195</td>\n",
       "      <td>58</td>\n",
       "      <td>12</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10077</th>\n",
       "      <td>10077</td>\n",
       "      <td>1471</td>\n",
       "      <td>1677</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10083</th>\n",
       "      <td>10083</td>\n",
       "      <td>859</td>\n",
       "      <td>1764</td>\n",
       "      <td>12</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10084</th>\n",
       "      <td>10084</td>\n",
       "      <td>1927</td>\n",
       "      <td>303</td>\n",
       "      <td>8</td>\n",
       "      <td>49</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10087</th>\n",
       "      <td>10087</td>\n",
       "      <td>1378</td>\n",
       "      <td>1046</td>\n",
       "      <td>6</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10097</th>\n",
       "      <td>10097</td>\n",
       "      <td>1105</td>\n",
       "      <td>1239</td>\n",
       "      <td>16</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10122</th>\n",
       "      <td>10122</td>\n",
       "      <td>1361</td>\n",
       "      <td>199</td>\n",
       "      <td>6</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10136</th>\n",
       "      <td>10136</td>\n",
       "      <td>1779</td>\n",
       "      <td>1824</td>\n",
       "      <td>16</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10147</th>\n",
       "      <td>10147</td>\n",
       "      <td>1136</td>\n",
       "      <td>664</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10151</th>\n",
       "      <td>10151</td>\n",
       "      <td>1353</td>\n",
       "      <td>569</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10168</th>\n",
       "      <td>10168</td>\n",
       "      <td>1770</td>\n",
       "      <td>1984</td>\n",
       "      <td>14</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10173</th>\n",
       "      <td>10173</td>\n",
       "      <td>1689</td>\n",
       "      <td>1610</td>\n",
       "      <td>8</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10182</th>\n",
       "      <td>10182</td>\n",
       "      <td>1243</td>\n",
       "      <td>970</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10184</th>\n",
       "      <td>10184</td>\n",
       "      <td>413</td>\n",
       "      <td>562</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10209</th>\n",
       "      <td>10209</td>\n",
       "      <td>569</td>\n",
       "      <td>1046</td>\n",
       "      <td>10</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10239</th>\n",
       "      <td>10239</td>\n",
       "      <td>1271</td>\n",
       "      <td>589</td>\n",
       "      <td>4</td>\n",
       "      <td>48</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10335</th>\n",
       "      <td>10335</td>\n",
       "      <td>841</td>\n",
       "      <td>27</td>\n",
       "      <td>14</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10352</th>\n",
       "      <td>10352</td>\n",
       "      <td>1764</td>\n",
       "      <td>1269</td>\n",
       "      <td>4</td>\n",
       "      <td>45</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10361</th>\n",
       "      <td>10361</td>\n",
       "      <td>1160</td>\n",
       "      <td>790</td>\n",
       "      <td>12</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10366</th>\n",
       "      <td>10366</td>\n",
       "      <td>398</td>\n",
       "      <td>107</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10371</th>\n",
       "      <td>10371</td>\n",
       "      <td>1953</td>\n",
       "      <td>1325</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10377</th>\n",
       "      <td>10377</td>\n",
       "      <td>398</td>\n",
       "      <td>1984</td>\n",
       "      <td>8</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10391</th>\n",
       "      <td>10391</td>\n",
       "      <td>1425</td>\n",
       "      <td>1968</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10395</th>\n",
       "      <td>10395</td>\n",
       "      <td>562</td>\n",
       "      <td>496</td>\n",
       "      <td>16</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10408</th>\n",
       "      <td>10408</td>\n",
       "      <td>932</td>\n",
       "      <td>173</td>\n",
       "      <td>6</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10410</th>\n",
       "      <td>10410</td>\n",
       "      <td>1428</td>\n",
       "      <td>1824</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109936</th>\n",
       "      <td>109936</td>\n",
       "      <td>27</td>\n",
       "      <td>22</td>\n",
       "      <td>16</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109937</th>\n",
       "      <td>109937</td>\n",
       "      <td>1933</td>\n",
       "      <td>156</td>\n",
       "      <td>12</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109938</th>\n",
       "      <td>109938</td>\n",
       "      <td>1189</td>\n",
       "      <td>1599</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109940</th>\n",
       "      <td>109940</td>\n",
       "      <td>1207</td>\n",
       "      <td>1677</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109941</th>\n",
       "      <td>109941</td>\n",
       "      <td>1540</td>\n",
       "      <td>1428</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109943</th>\n",
       "      <td>109943</td>\n",
       "      <td>496</td>\n",
       "      <td>1827</td>\n",
       "      <td>12</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109945</th>\n",
       "      <td>109945</td>\n",
       "      <td>1061</td>\n",
       "      <td>674</td>\n",
       "      <td>6</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109947</th>\n",
       "      <td>109947</td>\n",
       "      <td>1957</td>\n",
       "      <td>664</td>\n",
       "      <td>10</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109948</th>\n",
       "      <td>109948</td>\n",
       "      <td>664</td>\n",
       "      <td>1058</td>\n",
       "      <td>16</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109949</th>\n",
       "      <td>109949</td>\n",
       "      <td>1160</td>\n",
       "      <td>1764</td>\n",
       "      <td>6</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109951</th>\n",
       "      <td>109951</td>\n",
       "      <td>1239</td>\n",
       "      <td>1428</td>\n",
       "      <td>12</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109959</th>\n",
       "      <td>109959</td>\n",
       "      <td>790</td>\n",
       "      <td>1172</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109962</th>\n",
       "      <td>109962</td>\n",
       "      <td>693</td>\n",
       "      <td>1525</td>\n",
       "      <td>6</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109967</th>\n",
       "      <td>109967</td>\n",
       "      <td>1599</td>\n",
       "      <td>58</td>\n",
       "      <td>12</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109968</th>\n",
       "      <td>109968</td>\n",
       "      <td>1180</td>\n",
       "      <td>1764</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109969</th>\n",
       "      <td>109969</td>\n",
       "      <td>179</td>\n",
       "      <td>664</td>\n",
       "      <td>8</td>\n",
       "      <td>49</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109975</th>\n",
       "      <td>109975</td>\n",
       "      <td>635</td>\n",
       "      <td>120</td>\n",
       "      <td>8</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109978</th>\n",
       "      <td>109978</td>\n",
       "      <td>994</td>\n",
       "      <td>156</td>\n",
       "      <td>14</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109979</th>\n",
       "      <td>109979</td>\n",
       "      <td>1110</td>\n",
       "      <td>1984</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109981</th>\n",
       "      <td>109981</td>\n",
       "      <td>790</td>\n",
       "      <td>1540</td>\n",
       "      <td>4</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109983</th>\n",
       "      <td>109983</td>\n",
       "      <td>496</td>\n",
       "      <td>27</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109984</th>\n",
       "      <td>109984</td>\n",
       "      <td>223</td>\n",
       "      <td>790</td>\n",
       "      <td>8</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109985</th>\n",
       "      <td>109985</td>\n",
       "      <td>1378</td>\n",
       "      <td>684</td>\n",
       "      <td>16</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109987</th>\n",
       "      <td>109987</td>\n",
       "      <td>48</td>\n",
       "      <td>156</td>\n",
       "      <td>16</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109989</th>\n",
       "      <td>109989</td>\n",
       "      <td>1034</td>\n",
       "      <td>1677</td>\n",
       "      <td>16</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109990</th>\n",
       "      <td>109990</td>\n",
       "      <td>1957</td>\n",
       "      <td>1239</td>\n",
       "      <td>12</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109993</th>\n",
       "      <td>109993</td>\n",
       "      <td>841</td>\n",
       "      <td>1827</td>\n",
       "      <td>16</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109995</th>\n",
       "      <td>109995</td>\n",
       "      <td>199</td>\n",
       "      <td>684</td>\n",
       "      <td>10</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109996</th>\n",
       "      <td>109996</td>\n",
       "      <td>935</td>\n",
       "      <td>664</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109999</th>\n",
       "      <td>109999</td>\n",
       "      <td>1599</td>\n",
       "      <td>1764</td>\n",
       "      <td>14</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61440 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            id  from_id  to_id  speed  plan_time  priority  preset\n",
       "id                                                                \n",
       "10010    10010      706   1827     14         23         1       0\n",
       "10033    10033      634    176     14         17         1       1\n",
       "10039    10039     1901   1519      6         47         1       0\n",
       "10040    10040     1927   1009     16         20         1       1\n",
       "10050    10050     1195     58     12         33         1       0\n",
       "10077    10077     1471   1677     10         15         1       1\n",
       "10083    10083      859   1764     12         24         1       0\n",
       "10084    10084     1927    303      8         49         1       1\n",
       "10087    10087     1378   1046      6         25         1       0\n",
       "10097    10097     1105   1239     16         42         1       1\n",
       "10122    10122     1361    199      6         15         1       0\n",
       "10136    10136     1779   1824     16         28         1       1\n",
       "10147    10147     1136    664      6          4         1       0\n",
       "10151    10151     1353    569     10          5         1       0\n",
       "10168    10168     1770   1984     14         23         1       0\n",
       "10173    10173     1689   1610      8         34         1       0\n",
       "10182    10182     1243    970      6         36         1       0\n",
       "10184    10184      413    562     14          4         1       0\n",
       "10209    10209      569   1046     10         32         1       0\n",
       "10239    10239     1271    589      4         48         1       0\n",
       "10335    10335      841     27     14         42         1       1\n",
       "10352    10352     1764   1269      4         45         1       1\n",
       "10361    10361     1160    790     12         26         1       0\n",
       "10366    10366      398    107      4          8         1       0\n",
       "10371    10371     1953   1325     12          5         1       0\n",
       "10377    10377      398   1984      8         22         1       0\n",
       "10391    10391     1425   1968     14          7         1       1\n",
       "10395    10395      562    496     16         33         1       0\n",
       "10408    10408      932    173      6         17         1       0\n",
       "10410    10410     1428   1824      8          5         1       0\n",
       "...        ...      ...    ...    ...        ...       ...     ...\n",
       "109936  109936       27     22     16         22         0       0\n",
       "109937  109937     1933    156     12         18         0       0\n",
       "109938  109938     1189   1599     12          3         0       0\n",
       "109940  109940     1207   1677     12         31         0       0\n",
       "109941  109941     1540   1428      8          8         0       0\n",
       "109943  109943      496   1827     12         28         0       0\n",
       "109945  109945     1061    674      6         42         0       0\n",
       "109947  109947     1957    664     10         23         0       0\n",
       "109948  109948      664   1058     16         27         0       1\n",
       "109949  109949     1160   1764      6         45         0       0\n",
       "109951  109951     1239   1428     12         40         0       0\n",
       "109959  109959      790   1172     16         16         0       0\n",
       "109962  109962      693   1525      6         47         0       1\n",
       "109967  109967     1599     58     12         39         0       0\n",
       "109968  109968     1180   1764     12          4         0       0\n",
       "109969  109969      179    664      8         49         0       0\n",
       "109975  109975      635    120      8         17         0       0\n",
       "109978  109978      994    156     14         36         0       0\n",
       "109979  109979     1110   1984     12         12         0       0\n",
       "109981  109981      790   1540      4         48         0       0\n",
       "109983  109983      496     27      4         11         0       0\n",
       "109984  109984      223    790      8         37         0       0\n",
       "109985  109985     1378    684     16         18         0       0\n",
       "109987  109987       48    156     16          4         0       0\n",
       "109989  109989     1034   1677     16         35         0       0\n",
       "109990  109990     1957   1239     12         46         0       0\n",
       "109993  109993      841   1827     16         18         0       0\n",
       "109995  109995      199    684     10         39         0       0\n",
       "109996  109996      935    664     14          4         0       0\n",
       "109999  109999     1599   1764     14         47         0       1\n",
       "\n",
       "[61440 rows x 7 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cars_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAEXCAYAAACgUUN5AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAGdxJREFUeJzt3Xm4ZFV97vHvC0gcmO0DMjWHVhShL1MKQhQjAiraBGKiKIHLoAQxXkEjVxv1ucQIPp2b6xSNIEFsEiPKxQEENRIiV0UFTzPI0JgIHMaGPsyDEQO894+9DxSVM1Q1tav69Ho/z3OeU3utXb+19j516ldrr117yzYREVGutYbdgYiIGK4kgoiIwiURREQULokgIqJwSQQREYVLIoiIKFwSQcwZki6RdPQqPndc0n797tMU7TwiaUHT7XTRj5Ml3SPprmH3JVZ/SQQxK0l7SfqJpAcl3SfpUkm7D7tfnSRZ0qP1m/Edkj4pae0+xv9QHfsRSb+R9ETb8nUAttezfVO/2lzFfm4NvB/YwfaLpllnA0mflnRr3f9f1cvzBtvbWB0kEcSMJG0AXAB8FtgE2BL4KPDYMPs1g51trwfsC/wp8Gf9Cmz74/Ub/XrAscBPJ5dt79ivdvpgG+Be2yunqpS0LnAxsCOwP7AB8ArgXmCPXhuTtM6qdzVWB0kEMZuXAtg+2/YTtv/D9vdt/wJA0pH1COGz9YjhBkn7Tj5Z0oaSvihpRf0p/eT2T+mS3i5puaT7Jf2zpG3a6l5bx3tQ0ucAddtp2zcAPwIWdtZJ2kPSTyU9UPfrc/Wb42S9JR0r6d/rfv2dpK7arp/7kvrxUkmfl/Td+lP3pZJeVH/yvr/etl3bnruFpK9LmpB0s6TjZmhnQ0n/UK97i6SPSFqrPvx1EbBF3ebSKZ5+ODAfeJPt620/aXul7Y/Z/k4df7GkGyU9LOl6SW9qa3vyb/4pSfcBfynpJZL+X/23ukfS17rZX7F6SCKI2fwb8ISksyS9QdLGU6zze8BNwDzgJOAbkjap684CHgdeAuwKvA44GkDSHwEfAv4YGKF64z67rpsHfB34SB33RuCV3XZa0g7Aq4Arp6h+AnhfHff3qUYPf96xzgHA7sDOwMHA67ttu8PBPL0NjwE/Ba6ol88FPln3dy3g28DVVKOufYH3Spqu3c8CGwILgFdTvbkfZftfgDcAd9YjlSOneO5+wPdsPzJDv2+k2n8bUo0Avyxp87b6yb/5psApwMeA7wMbA1vV/Yu5wnZ+8jPjD/ByYClwO9Wb+vnAZnXdkcCdgNrWvxz478BmVG9+z2urOwT4Qf34u8A72urWAn5NdWjjcOBnbXWq2z96hn4aeAi4n+qN7GRgrbpuHNhvmue9F/hmR5y92pbPARZ3POdI4MfT9OEl9eOlwN+31b0HWN62/N+AB+rHvwfc2hHrROBLU7Sxdr1fd2greydwSf14b+D2GfbTRcCSHl8DVwEHtW17Z1//ATgd2GrYr9f89P6TEUHMyvZy20fa3orqUMsWwKfbVrnD9btB7ZZ6nW2A5wAr6sMwDwBfoPoUSV3/mba6+6je8Lesn39bWx/cvizpuraJ2le1tb2b7Y1tv9j2R2w/2bk9kl4q6QJJd0l6CPg41Sf0du1n2/waWG+W3TSdu9se/8cUy5Nxt6E6nPNA2/74EFUy7TQPWJdqP0+6hWq/deNeYPOZVpB0uKSr2vqykGfuo9s6nvIBqr/d5fXf5u1d9iVWA0kE0RNXx96X8sxj71t2HEOfTzVKuI3qk+s82xvVPxv46YnV24B3ttVtZPt5tn8CrAC2ngxYx39q2faOfnqi9kc9bsapwA3AdrY3oHrD7Xr+oSG3ATd37Iv1bb9xinXvAf6TKnlMmg/c0WVb/wK8XtILpqqs52n+HvgfwAttbwRcyzP30TMuW2z7Ltt/ZnsLqtHJ5yfnSmL1l0QQM5K0vaT3S9qqXt6a6vDOz9pW2xQ4TtJzJL2F6lDSd2yvoDpu/AlVpyuuJenFkl5dP+804ERJO9axN6yfD3AhsKOkP1Z1VspxwJSnQq6C9akOIT0iaXvgXX2K+2xcDjwk6YOSnidpbUkLNcVpurafoDpcdYqk9es37r8AvtxlW/9IlXi+Xv9915L0QlWnx74ReAHVG/0EgKSjmGLSvZ2kt0y+RqgOzZlqLibmgCSCmM3DVMevL5P0KFUCuJbqPPVJlwHbUX1SPQV4s+1767rDqQ5jXE/1BnEu9WEJ298E/hr4an2I5lqqiU5s3wO8BVhCdShjO+DSPm3TCVSnlj5M9cl36Ge41G/ufwjsAtxMtS/PoJqsncp7gEepJmx/DHwFOLPLth6jmjC+gWq+4CGqRDQPuMz29cAnqCa276aay5ht3+9O9Rp5hGoO6XjbN3fTnxg+PfPQbkRvJB1JNYG717D7EhGrJiOCiIjCJRFERBQuh4YiIgqXEUFEROHmxMWi5s2b59HR0WF3IyJiTlm2bNk9tkdmW29OJILR0VHGxsaG3Y2IiDlF0i2zr5VDQxERxUsiiIgoXBJBREThkggiIgqXRBARUbjGEoGkMyWtlHRtR/l7JP2yvmb5/26q/YiI6E6Tp48uBT5HdeciACS9BjgI2Mn2Y5I2nea5fTG6+MKnHo8vWdRVXa/liZVYiZVYg47Vb42NCGz/kOqOU+3eRXWLvMfqdVY21X77Tuxcnq6u1/LESqzESqxBx2pCo9cakjQKXGB7Yb18FXAesD/wG+AE2z+fLU6r1XIvXyhreqdFRAxDryMDSctst2Zbb9DfLF4H2BjYk+pGFudIWuApspGkY4BjAObPnz/QTkZElGTQZw3dDnzDlcuBJ/mvNw0HwPbptlu2WyMjIwPtZERESQadCL4F7AMg6aVUtzC8p9+NTDd8Gl+yaMa6xEqsxEqs1TlWU5o8ffRsqnuevkzS7ZLeQXVP1QX1KaVfBY6Y6rBQP3TutPbl6ep6LU+sxEqsxBp0rCbMiRvT9DpZHBER3U8W55vFERGFSyKIiChcEkFEROGSCCIiCpdEEBFRuCSCiIjCJRFERBQuiSAionBJBBERhUsiiIgoXBJBREThkggiIgqXRBARUbgkgoiIwiURREQULokgIqJwSQQREYVLIoiIKFwSQURE4ZIIIiIKl0QQEVG4JIKIiMIlEUREFC6JICKicOs0FVjSmcABwErbCzvqTgD+BhixfU9TfRhdfOFTj8eXLOqqrtfyxEqsxEqsQcfqtyZHBEuB/TsLJW0NvBa4tcG2n7ETO5enq+u1PLESK7ESa9CxmiDbzQWXRoEL2kcEks4FPgacB7S6GRG0Wi2PjY113W7TOy0iYhh6HRlIWma7Ndt6A50jkHQgcIftq7tY9xhJY5LGJiYmBtC7iIgyDSwRSHo+8GHgf3Wzvu3Tbbdst0ZGRprtXEREwQY5IngxsC1wtaRxYCvgCkkv6ndD0w2fxpcsmrEusRIrsRJrdY7VlIElAtvX2N7U9qjtUeB2YDfbdzXRXudOa1+erq7X8sRKrMRKrEHHakJjk8WSzgb2BuYBdwMn2f5iW/04DU0WR0RE95PFjX2PwPYhs9SPNtV2RER0L98sjogoXBJBREThkggiIgqXRBARUbgkgoiIwiURREQULokgIqJwSQQREYVLIoiIKFwSQURE4ZIIIiIKl0QQEVG4JIKIiMIlEUREFC6JICKicEkEERGFSyKIiChcEkFEROGSCCIiCpdEEBFRuCSCiIjCJRFERBQuiSAionBJBBERhVunqcCSzgQOAFbaXliX/Q3wh8BvgRuBo2w/0FQfRhdf+NTj8SWLuqrrtTyxEiuxEmvQsfqtyRHBUmD/jrKLgIW2dwL+DTixqcbbd2Ln8nR1vZYnVmIlVmINOlYTZLu54NIocMHkiKCj7k3Am20fOlucVqvlsbGxrttteqdFRAxDryMDSctst2Zbb5hzBG8HvjtdpaRjJI1JGpuYmBhgtyIiyjKURCDpw8DjwD9Nt47t0223bLdGRkYG17mIiMIMPBFIOoJqEvlQN3Rcarrh0/iSRTPWJVZiJVZirc6xmjLQRCBpf+CDwIG2f91kW507rX15urpeyxMrsRIrsQYdqwmNTRZLOhvYG5gH3A2cRHWW0O8A99ar/cz2sbPF6nWyOCIiup8sbux7BLYPmaL4i021FxERqybfLI6IKFwSQURE4ZIIIiIKl0QQEVG4JIKIiMIlEUREFC6JICKicEkEERGFSyKIiChcEkFEROGSCCIiCpdEEBFRuCSCiIjCJRFERBQuiSAionAz3o9A0m4z1du+or/diYiIQZvtxjSfqH8/F2gBVwMCdgIuA/ZqrmsRETEIMx4asv0a268BbgF2s92y/bvArsCvBtHBiIhoVrdzBNvbvmZywfa1wC7NdCkiIgap23sWL5d0BvBlwMBhwPLGehUREQPTbSI4CngXcHy9/EPg1EZ6FBERA9VVIrD9G0mnAd+x/cuG+xQREQPU1RyBpAOBq4Dv1cu7SDq/yY5FRMRgdDtZfBKwB/AAgO2rgNGG+hQREQPU7RzB47YflNR1YElnAgcAK20vrMs2Ab5GlUTGgYNt399Lh3sxuvjCpx6PL1nUVV2v5YmVWImVWIOO1W/djgiulfSnwNqStpP0WeAnszxnKbB/R9li4GLb2wEX18uNaN+JncvT1fVanliJlViJNehYTZDt2VeSng98GHhdXfTPwMm2fzPL80aBC9pGBL8E9ra9QtLmwCW2XzZb+61Wy2NjY7P2c1LTOy0iYhh6HRlIWma7Ndt63Z419Gvgw5I+bvvRnnryTJvZXlHHXCFp0+lWlHQMcAzA/Pnzn0WTERExk27PGnqFpOupv0QmaWdJn2+yY7ZPry9p0RoZGWmyqYiIonU7R/Ap4PXAvQC2rwb+YBXau7s+JET9e+UqxJjVdMOn8SWLZqxLrMRKrMRanWM1pev7Edi+raPoiVVo73zgiPrxEcB5qxCjK507rX15urpeyxMrsRIrsQYdqwndThafC3wS+BywJ3Ac0LL9thmeczawNzAPuJvquwjfAs4B5gO3Am+xfd9s7fc6WRwREX2eLAaOBT4DbAncQXXW0LtneoLtQ6ap2rfLNiMiYgC6PWvoHuDQhvsSERFD0O1ZQwskfVvShKSVks6TtKDpzkVERPO6nSz+CtWx/c2BLYD/C5zdVKciImJwuk0Esv2Pth+vfyZvUBMREXNct5PFP5C0GPgqVQJ4K3BhfRE5ujnzJyIiVk/dJoK31r/fydMjAQFvr5czXxARMUd1e2jog8DOtrcFvgRcDfyJ7W1tJwlERMxh3SaCj9h+SNJewGupLjGdexZHRKwBuk0Ek5eTWAScZvs8YN1muhQREYPUbSK4Q9IXgIOB70j6nR6eGxERq7Fu38wPprqsxP62HwA2Af5nY72KiIiB6eXGNN9oW14BrGiqUxERMTg5vBMRUbgkgoiIwiURREQULokgIqJwSQQREYVLIoiIKFwSQURE4ZIIIiIKl0QQEVG4JIKIiMIlEUREFC6JICKicN3eqrKvJL0POJrqNpfXAEfZ/k2/2xldfOFTj8eXLOqqrtfyxEqsxEqsQcfqt4GPCCRtCRwHtGwvBNYG3tbvdtp3YufydHW9lidWYiVWYg06VhNke/a1+tlglQh+BuwMPAR8C/hb29+f7jmtVstjY2Ndt9H0TouIGIZeRwaSltluzbbewEcEtu8A/g9wK9U9DR6cKglIOkbSmKSxiYmJQXczIqIYwzg0tDFwELAtsAXwAkmHda5n+3TbLdutkZGRQXczIqIYwzhraD/gZtsTtv+T6s5nr+hnA9MNn8aXLJqxLrESK7ESa3WO1ZRhJIJbgT0lPV+SgH2B5f1upHOntS9PV9dreWIlVmIl1qBjNWHgk8UAkj4KvBV4HLgSONr2Y9Ot3+tkcUREdD9ZPJTvEdg+CThpGG1HRMQz5ZvFERGFSyKIiChcEkFEROGSCCIiCpdEEBFRuCSCiIjCJRFERBQuiSAionBJBBERhUsiiIgoXBJBREThkggiIgqXRBARUbgkgoiIwiURREQULokgIqJwSQQREYVLIoiIKFwSQURE4ZIIIiIKl0QQEVG4JIKIiMIlEUREFC6JICKicOsMo1FJGwFnAAsBA2+3/dN+tzO6+MKnHo8vWdRVXa/liZVYiZVYg47Vb8MaEXwG+J7t7YGdgeX9bqB9J3YuT1fXa3liJVZiJdagYzVBthtt4L80KG0AXA0scJeNt1otj42Ndd1G0zstImIYeh0ZSFpmuzXbesMYESwAJoAvSbpS0hmSXtC5kqRjJI1JGpuYmBh8LyMiCjGMRLAOsBtwqu1dgUeBxZ0r2T7ddst2a2RkZNB9jIgoxjASwe3A7bYvq5fPpUoMfTPd8Gl8yaIZ6xIrsRIrsVbnWE0ZeCKwfRdwm6SX1UX7Atf3u53Onda+PF1dr+WJlViJlViDjtWEgU8WA0jaher00XWBm4CjbN8/3fq9ThZHRET3k8VD+R6B7auAWTsXERHNyzeLIyIKl0QQEVG4JIKIiMIlEUREFC6JICKicEkEERGFSyKIiChcEkFEROGSCCIiCpdEEBFRuCSCiIjCJRFERBQuiSAionBJBBERhUsiiIgoXBJBREThkggiIgqXRBARUbgkgoiIwiURREQULokgIqJwSQQREYVLIoiIKFwSQURE4dYZVsOS1gbGgDtsH9BEG6OLL3zq8fiSRV3V9VqeWImVWIk16Fj9NswRwfHA8qaCt+/EzuXp6notT6zESqzEGnSsJsh2ow1M2ai0FXAWcArwF7ONCFqtlsfGxrqO3/ROi4gYhl5HBpKW2W7Ntt6wRgSfBj4APDndCpKOkTQmaWxiYmJwPYuIKMzAE4GkA4CVtpfNtJ7t0223bLdGRkYG1LuIiPIMY0TwSuBASePAV4F9JH25nw1MN3waX7JoxrrESqzESqzVOVZTBp4IbJ9oeyvbo8DbgH+1fVi/2+ncae3L09X1Wp5YiZVYiTXoWE0YymTxU41LewMn9HuyOCIiup8sHtr3CABsXwJcMsw+RESULt8sjogoXBJBREThkggiIgqXRBARUbihnjXULUkTwC2zrDYPuGcA3VkdlbztUPb2Z9vL1c32b2N71m/kzolE0A1JY92cJrUmKnnboeztz7aXue3Q3+3PoaGIiMIlEUREFG5NSgSnD7sDQ1TytkPZ259tL1fftn+NmSOIiIhVsyaNCCIiYhUkEUREFG7OJwJJ+0v6paRfSVo87P40TdKZklZKuratbBNJF0n69/r3xsPsY1MkbS3pB5KWS7pO0vF1eSnb/1xJl0u6ut7+j9bl20q6rN7+r0lad9h9bYqktSVdKemCermIbZc0LukaSVdJGqvL+va6n9OJQNLawN8BbwB2AA6RtMNwe9W4pcD+HWWLgYttbwdcXC+viR4H3m/75cCewLvrv3cp2/8YsI/tnYFdgP0l7Qn8NfCpevvvB94xxD427XhgedtySdv+Gtu7tH13oG+v+zmdCIA9gF/Zvsn2b6nueHbQkPvUKNs/BO7rKD4IOKt+fBbwRwPt1IDYXmH7ivrxw1RvCFtSzvbb9iP14nPqHwP7AOfW5Wvs9kvaClgEnFEvi0K2fRp9e93P9USwJXBb2/LtdVlpNrO9Aqo3S2DTIfencZJGgV2Byyho++tDI1cBK4GLgBuBB2w/Xq+yJv8PfBr4APBkvfxCytl2A9+XtEzSMXVZ3173Q70xTR9oirKcD7uGk7Qe8HXgvbYfqj4YlsH2E8AukjYCvgm8fKrVBtur5kk6AFhpe1l9Z0Mo6///lbbvlLQpcJGkG/oZfK6PCG4Htm5b3gq4c0h9Gaa7JW0OUP9eOeT+NEbSc6iSwD/Z/kZdXMz2T7L9ANXd/fYENpI0+aFuTf0feCVwoKRxqkPA+1CNEErYdmzfWf9eSfUBYA/6+Lqf64ng58B29ZkD6wJvA84fcp+G4XzgiPrxEcB5Q+xLY+pjwl8Eltv+ZFtVKds/Uo8EkPQ8YD+qeZIfAG+uV1sjt9/2iba3sj1K9X/+r7YPpYBtl/QCSetPPgZeB1xLH1/3c/6bxZLeSPXJYG3gTNunDLlLjZJ0NrA31SVo7wZOAr4FnAPMB24F3mK7c0J5zpO0F/Aj4BqePk78Iap5ghK2fyeqScG1qT7EnWP7ryQtoPqUvAlwJXCY7ceG19Nm1YeGTrB9QAnbXm/jN+vFdYCv2D5F0gvp0+t+zieCiIh4dub6oaGIiHiWkggiIgqXRBARUbgkgoiIwiURREQULokgIqJwSQRRLEmXSGrNvmbX8faW9Iq25WMlHd6v+BFNmevXGopYnewNPAL8BMD2aUPtTUSXMiKINZ6kUUk3SDpL0i8knSvp+R3rnCpprP2GL3X5uKSPSrqivjHI9tO1ARwLvK++ecirJP2lpBPq+kskfUrSD+sb6+wu6Rv1TUVObotzWH3zmaskfaG+50ZEo5IIohQvA063vRPwEPDnHfUfrm/4sRPw6vpyDpPusb0bcCpwwlTBbY8Dp1HdJGUX2z+aYrXf2v6Der3zgHcDC4EjJb1Q0suBt1JdaXIX4Ang0FXb3IjuJRFEKW6zfWn9+MvAXh31B0u6gup6NTtS3fFu0uRVTpcBo8+iD5MXRLwGuK6+0c5jwE1UV9HdF/hd4Of1PQf2BRY8i/YiupI5gihF50W1nlqWtC3VJ/3dbd8vaSnw3LZ1Jy9i9gTP7n9mMs6TbY8nl9ehur7+WbZPfBZtRPQsI4IoxXxJv18/PgT4cVvdBsCjwIOSNqO6B/aqeBhYf9W7yMXAm+ubj0zenHybZxEvoitJBFGK5cARkn5BdcniUycrbF9NdUjoOuBM4NIpI8zu28CbJieLe32y7euBj1DdkvAXVLei3HwV+xLRtVyGOtZ49Rk9F9heOOSuRKyWMiKIiChcRgQRPZJ0FHB8R/Gltt89jP5EPFtJBBERhcuhoYiIwiURREQULokgIqJwSQQREYX7/zvXNU3ZWZa5AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "cars_df.plot(kind='scatter', x='plan_time', y='speed', title='Speed-PlanTime of Cars');"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>real_time</th>\n",
       "      <th>preset_path</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21701</td>\n",
       "      <td>1</td>\n",
       "      <td>[5175, 6484, 6549, 6225, 5489, 6081, 6970, 509...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>14627</td>\n",
       "      <td>1</td>\n",
       "      <td>[5470, 6939, 6716, 5345, 6566, 6997, 5714, 530...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>87977</td>\n",
       "      <td>1</td>\n",
       "      <td>[5029, 5742, 6284, 5175, 5184, 5608, 5453, 689...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>106621</td>\n",
       "      <td>1</td>\n",
       "      <td>[5507, 5860, 5660, 5306, 5882, 6369, 6970, 550...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>24316</td>\n",
       "      <td>1</td>\n",
       "      <td>[5222, 5076, 5306, 5660, 5860, 5507, 6472, 545...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>64146</td>\n",
       "      <td>1</td>\n",
       "      <td>[5742, 6284, 5175, 5184, 5608, 5453, 6892, 636...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>36111</td>\n",
       "      <td>1</td>\n",
       "      <td>[5906, 6552, 6028, 5593, 6583, 5386, 5345, 650...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>35442</td>\n",
       "      <td>1</td>\n",
       "      <td>[6586, 5905, 5713, 6365, 6543, 5306, 5882, 636...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>36873</td>\n",
       "      <td>1</td>\n",
       "      <td>[5714, 5306, 5660, 6796, 6361, 6892, 5453, 560...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>95520</td>\n",
       "      <td>1</td>\n",
       "      <td>[6449, 5206, 5207, 5326, 5632, 5505, 6081, 671...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>100017</td>\n",
       "      <td>1</td>\n",
       "      <td>[5408, 6629, 5481, 6450, 6012, 6586, 5905, 654...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>32857</td>\n",
       "      <td>1</td>\n",
       "      <td>[5181, 6288, 6568, 5175, 5184, 5608, 5453, 689...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>107106</td>\n",
       "      <td>1</td>\n",
       "      <td>[5923, 5742, 6284, 5175, 6484, 6549, 6225, 548...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>25948</td>\n",
       "      <td>1</td>\n",
       "      <td>[5278, 5247, 5456, 6152, 6200, 5574, 6450, 601...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>95194</td>\n",
       "      <td>1</td>\n",
       "      <td>[5831, 5475, 5632, 5505, 6081, 6719, 5540, 644...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>79538</td>\n",
       "      <td>1</td>\n",
       "      <td>[5175, 6484, 6549, 6225, 5489, 6081, 6970, 509...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>31866</td>\n",
       "      <td>1</td>\n",
       "      <td>[5204, 6828, 6568, 5175, 5184, 5792, 5378, 577...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>20727</td>\n",
       "      <td>1</td>\n",
       "      <td>[6653, 6627, 5222, 5076, 5306, 5660, 6796, 636...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>37032</td>\n",
       "      <td>1</td>\n",
       "      <td>[6444, 6361, 6058, 5507, 6472, 6152, 6200, 557...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>78679</td>\n",
       "      <td>1</td>\n",
       "      <td>[6909, 6327, 5731, 6158, 5270, 5244, 5526, 512...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>88585</td>\n",
       "      <td>1</td>\n",
       "      <td>[5026, 6875, 5714, 5306, 6543, 6365, 6433, 594...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>34097</td>\n",
       "      <td>1</td>\n",
       "      <td>[5731, 5278, 5247, 5456, 6472, 5507, 5860, 566...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>53140</td>\n",
       "      <td>1</td>\n",
       "      <td>[5278, 5247, 5456, 6152, 6200, 5574, 6450, 601...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>85593</td>\n",
       "      <td>1</td>\n",
       "      <td>[5713, 6545, 5507, 6472, 5456, 6065, 6124, 511...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>86070</td>\n",
       "      <td>1</td>\n",
       "      <td>[6719, 5540, 6444, 6796, 5860, 5507, 6472, 615...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>24993</td>\n",
       "      <td>1</td>\n",
       "      <td>[6235, 5612, 5269, 6236, 6805, 5129, 5921, 518...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>48372</td>\n",
       "      <td>1</td>\n",
       "      <td>[5477, 5847, 5640, 6001, 5218, 5133, 6586, 590...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>106984</td>\n",
       "      <td>1</td>\n",
       "      <td>[6444, 6796, 5860, 5507, 6472, 6152, 6200, 557...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>47875</td>\n",
       "      <td>1</td>\n",
       "      <td>[5339, 6001, 5640, 5847, 5469, 6653, 6540, 650...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>58677</td>\n",
       "      <td>1</td>\n",
       "      <td>[5289, 6048, 5505, 6081, 6719, 6430, 5034, 566...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12121</th>\n",
       "      <td>69042</td>\n",
       "      <td>756</td>\n",
       "      <td>[6012, 6586, 5905, 6545, 5860, 6796, 6444, 554...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12122</th>\n",
       "      <td>102012</td>\n",
       "      <td>756</td>\n",
       "      <td>[5795, 6450, 6012, 6586, 5905, 5713, 6365, 654...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12123</th>\n",
       "      <td>99579</td>\n",
       "      <td>756</td>\n",
       "      <td>[6484, 5184, 5608, 5453, 6892, 6058, 5507, 647...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12124</th>\n",
       "      <td>83559</td>\n",
       "      <td>756</td>\n",
       "      <td>[5746, 6650, 5133, 6586, 5905, 6908, 5542, 615...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12125</th>\n",
       "      <td>94165</td>\n",
       "      <td>756</td>\n",
       "      <td>[5953, 5644, 6805, 5129, 5921, 6484, 6549, 622...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12126</th>\n",
       "      <td>60111</td>\n",
       "      <td>756</td>\n",
       "      <td>[5795, 6450, 6012, 6586, 5905, 6545, 6058, 689...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12127</th>\n",
       "      <td>19411</td>\n",
       "      <td>756</td>\n",
       "      <td>[6369, 6970, 6081, 5489, 6225, 6549, 6484, 592...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12128</th>\n",
       "      <td>105997</td>\n",
       "      <td>756</td>\n",
       "      <td>[5709, 6387, 6530, 6810, 6795, 5247, 6065, 612...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12129</th>\n",
       "      <td>66727</td>\n",
       "      <td>756</td>\n",
       "      <td>[6545, 6058, 6892, 5453, 5608, 5184, 5175, 656...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12130</th>\n",
       "      <td>109515</td>\n",
       "      <td>756</td>\n",
       "      <td>[6065, 5456, 6472, 5507, 5860, 5660, 5034, 623...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12131</th>\n",
       "      <td>35710</td>\n",
       "      <td>756</td>\n",
       "      <td>[5745, 6327, 5731, 5278, 5247, 5456, 6152, 620...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12132</th>\n",
       "      <td>106862</td>\n",
       "      <td>756</td>\n",
       "      <td>[6627, 5222, 5076, 5306, 5660, 5860, 6058, 689...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12133</th>\n",
       "      <td>93569</td>\n",
       "      <td>756</td>\n",
       "      <td>[5847, 5640, 6001, 5218, 5133, 6586, 5905, 654...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12134</th>\n",
       "      <td>20396</td>\n",
       "      <td>756</td>\n",
       "      <td>[6909, 5745, 5422, 5680, 6096, 5244, 5526, 512...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12135</th>\n",
       "      <td>45497</td>\n",
       "      <td>756</td>\n",
       "      <td>[6478, 6892, 6058, 5860, 5660, 5034, 6234, 588...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12136</th>\n",
       "      <td>62347</td>\n",
       "      <td>756</td>\n",
       "      <td>[6433, 5713, 6908, 5542, 6152, 5456, 5247, 527...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12137</th>\n",
       "      <td>60005</td>\n",
       "      <td>756</td>\n",
       "      <td>[5713, 6908, 5542, 6152, 5456, 6065, 6124, 511...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12138</th>\n",
       "      <td>16864</td>\n",
       "      <td>756</td>\n",
       "      <td>[5680, 6096, 5244, 5526, 5129, 5921, 6484, 654...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12139</th>\n",
       "      <td>44782</td>\n",
       "      <td>756</td>\n",
       "      <td>[5470, 6939, 6716, 5345, 6566, 6997, 5714, 530...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12140</th>\n",
       "      <td>100791</td>\n",
       "      <td>756</td>\n",
       "      <td>[5860, 5507, 6472, 5456, 6065, 6124, 5116, 570...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12141</th>\n",
       "      <td>68869</td>\n",
       "      <td>756</td>\n",
       "      <td>[5746, 6650, 5133, 6586, 5905, 6545, 6058, 689...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12142</th>\n",
       "      <td>13339</td>\n",
       "      <td>756</td>\n",
       "      <td>[5519, 5207, 5326, 5632, 5505, 6081, 6719, 643...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12143</th>\n",
       "      <td>54223</td>\n",
       "      <td>756</td>\n",
       "      <td>[5759, 6997, 5714, 5306, 5660, 5860, 5507, 647...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12144</th>\n",
       "      <td>15924</td>\n",
       "      <td>756</td>\n",
       "      <td>[6188, 6236, 6805, 5129, 5921, 6484, 6549, 622...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12145</th>\n",
       "      <td>95375</td>\n",
       "      <td>756</td>\n",
       "      <td>[6449, 5206, 5207, 5326, 5632, 5505, 6970, 511...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12146</th>\n",
       "      <td>94636</td>\n",
       "      <td>756</td>\n",
       "      <td>[6327, 5731, 5278, 5247, 5456, 6472, 5507, 586...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12147</th>\n",
       "      <td>100245</td>\n",
       "      <td>756</td>\n",
       "      <td>[5612, 5269, 6236, 6805, 5129, 5921, 6484, 654...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12148</th>\n",
       "      <td>76842</td>\n",
       "      <td>756</td>\n",
       "      <td>[5953, 5644, 6805, 5129, 5921, 6484, 6549, 622...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12149</th>\n",
       "      <td>15782</td>\n",
       "      <td>756</td>\n",
       "      <td>[5181, 6288, 6568, 5175, 5184, 5608, 5453, 689...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12150</th>\n",
       "      <td>67619</td>\n",
       "      <td>756</td>\n",
       "      <td>[6794, 5923, 5742, 6284, 5175, 6484, 6549, 622...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12151 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           id  real_time                                        preset_path\n",
       "0       21701          1  [5175, 6484, 6549, 6225, 5489, 6081, 6970, 509...\n",
       "1       14627          1  [5470, 6939, 6716, 5345, 6566, 6997, 5714, 530...\n",
       "2       87977          1  [5029, 5742, 6284, 5175, 5184, 5608, 5453, 689...\n",
       "3      106621          1  [5507, 5860, 5660, 5306, 5882, 6369, 6970, 550...\n",
       "4       24316          1  [5222, 5076, 5306, 5660, 5860, 5507, 6472, 545...\n",
       "5       64146          1  [5742, 6284, 5175, 5184, 5608, 5453, 6892, 636...\n",
       "6       36111          1  [5906, 6552, 6028, 5593, 6583, 5386, 5345, 650...\n",
       "7       35442          1  [6586, 5905, 5713, 6365, 6543, 5306, 5882, 636...\n",
       "8       36873          1  [5714, 5306, 5660, 6796, 6361, 6892, 5453, 560...\n",
       "9       95520          1  [6449, 5206, 5207, 5326, 5632, 5505, 6081, 671...\n",
       "10     100017          1  [5408, 6629, 5481, 6450, 6012, 6586, 5905, 654...\n",
       "11      32857          1  [5181, 6288, 6568, 5175, 5184, 5608, 5453, 689...\n",
       "12     107106          1  [5923, 5742, 6284, 5175, 6484, 6549, 6225, 548...\n",
       "13      25948          1  [5278, 5247, 5456, 6152, 6200, 5574, 6450, 601...\n",
       "14      95194          1  [5831, 5475, 5632, 5505, 6081, 6719, 5540, 644...\n",
       "15      79538          1  [5175, 6484, 6549, 6225, 5489, 6081, 6970, 509...\n",
       "16      31866          1  [5204, 6828, 6568, 5175, 5184, 5792, 5378, 577...\n",
       "17      20727          1  [6653, 6627, 5222, 5076, 5306, 5660, 6796, 636...\n",
       "18      37032          1  [6444, 6361, 6058, 5507, 6472, 6152, 6200, 557...\n",
       "19      78679          1  [6909, 6327, 5731, 6158, 5270, 5244, 5526, 512...\n",
       "20      88585          1  [5026, 6875, 5714, 5306, 6543, 6365, 6433, 594...\n",
       "21      34097          1  [5731, 5278, 5247, 5456, 6472, 5507, 5860, 566...\n",
       "22      53140          1  [5278, 5247, 5456, 6152, 6200, 5574, 6450, 601...\n",
       "23      85593          1  [5713, 6545, 5507, 6472, 5456, 6065, 6124, 511...\n",
       "24      86070          1  [6719, 5540, 6444, 6796, 5860, 5507, 6472, 615...\n",
       "25      24993          1  [6235, 5612, 5269, 6236, 6805, 5129, 5921, 518...\n",
       "26      48372          1  [5477, 5847, 5640, 6001, 5218, 5133, 6586, 590...\n",
       "27     106984          1  [6444, 6796, 5860, 5507, 6472, 6152, 6200, 557...\n",
       "28      47875          1  [5339, 6001, 5640, 5847, 5469, 6653, 6540, 650...\n",
       "29      58677          1  [5289, 6048, 5505, 6081, 6719, 6430, 5034, 566...\n",
       "...       ...        ...                                                ...\n",
       "12121   69042        756  [6012, 6586, 5905, 6545, 5860, 6796, 6444, 554...\n",
       "12122  102012        756  [5795, 6450, 6012, 6586, 5905, 5713, 6365, 654...\n",
       "12123   99579        756  [6484, 5184, 5608, 5453, 6892, 6058, 5507, 647...\n",
       "12124   83559        756  [5746, 6650, 5133, 6586, 5905, 6908, 5542, 615...\n",
       "12125   94165        756  [5953, 5644, 6805, 5129, 5921, 6484, 6549, 622...\n",
       "12126   60111        756  [5795, 6450, 6012, 6586, 5905, 6545, 6058, 689...\n",
       "12127   19411        756  [6369, 6970, 6081, 5489, 6225, 6549, 6484, 592...\n",
       "12128  105997        756  [5709, 6387, 6530, 6810, 6795, 5247, 6065, 612...\n",
       "12129   66727        756  [6545, 6058, 6892, 5453, 5608, 5184, 5175, 656...\n",
       "12130  109515        756  [6065, 5456, 6472, 5507, 5860, 5660, 5034, 623...\n",
       "12131   35710        756  [5745, 6327, 5731, 5278, 5247, 5456, 6152, 620...\n",
       "12132  106862        756  [6627, 5222, 5076, 5306, 5660, 5860, 6058, 689...\n",
       "12133   93569        756  [5847, 5640, 6001, 5218, 5133, 6586, 5905, 654...\n",
       "12134   20396        756  [6909, 5745, 5422, 5680, 6096, 5244, 5526, 512...\n",
       "12135   45497        756  [6478, 6892, 6058, 5860, 5660, 5034, 6234, 588...\n",
       "12136   62347        756  [6433, 5713, 6908, 5542, 6152, 5456, 5247, 527...\n",
       "12137   60005        756  [5713, 6908, 5542, 6152, 5456, 6065, 6124, 511...\n",
       "12138   16864        756  [5680, 6096, 5244, 5526, 5129, 5921, 6484, 654...\n",
       "12139   44782        756  [5470, 6939, 6716, 5345, 6566, 6997, 5714, 530...\n",
       "12140  100791        756  [5860, 5507, 6472, 5456, 6065, 6124, 5116, 570...\n",
       "12141   68869        756  [5746, 6650, 5133, 6586, 5905, 6545, 6058, 689...\n",
       "12142   13339        756  [5519, 5207, 5326, 5632, 5505, 6081, 6719, 643...\n",
       "12143   54223        756  [5759, 6997, 5714, 5306, 5660, 5860, 5507, 647...\n",
       "12144   15924        756  [6188, 6236, 6805, 5129, 5921, 6484, 6549, 622...\n",
       "12145   95375        756  [6449, 5206, 5207, 5326, 5632, 5505, 6970, 511...\n",
       "12146   94636        756  [6327, 5731, 5278, 5247, 5456, 6472, 5507, 586...\n",
       "12147  100245        756  [5612, 5269, 6236, 6805, 5129, 5921, 6484, 654...\n",
       "12148   76842        756  [5953, 5644, 6805, 5129, 5921, 6484, 6549, 622...\n",
       "12149   15782        756  [5181, 6288, 6568, 5175, 5184, 5608, 5453, 689...\n",
       "12150   67619        756  [6794, 5923, 5742, 6284, 5175, 6484, 6549, 622...\n",
       "\n",
       "[12151 rows x 3 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "preset_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
